Design, build, enhance, and maintain fault-tolerant batch-based and real-time ETL processes to make new and existing data sources readily available to analysts, applications, and external business partners
Design and build data warehouses/data lakes/data marts to provide easy access to structured and semi-structured data for analysts and data scientists
Design, build, enhance, and maintain Power BI and SSRS reports and dashboards working from specification documents and/or direct interaction with business users
Automate manual data processes and optimize user queries
Decipher existing reports and database processes to assist users, analysts, and data stewards in understanding reports
Set up internal and external secure data exchanges using industry-standard encryption techniques
Implement data security measures to protect PII and other sensitive information
Integrate processes and tools to monitor and improve data quality and system stability as prescribed by the data governance team
Complete work with an emphasis on efficiency, quality, and maintainability

Minimum of bachelor’s degree required
Professional or educational experience in ETL, Business Intelligence, or Statistical Analytics required
Strong understanding of SQL including basic joins, inserts, updates, deletes, conditional logic, subqueries, temp tables, and data transformation functions
Proficient knowledge of relational database management systems required
Experience reviewing datasets for data quality required
Experience with un
or semi-structured data (ex. XML, JSON) preferred
Experience with any data integration tool preferred
Experience with reporting platform like Power BI and SSRS preferred
Experience with different data security algorithms preferred
Intrinsically motivated with demonstrated ability to take initiative, identify needs, make recommendations for improvement, see recommendations through implementation, and evaluate improvements for effectiveness
Strong verbal and written communication skills
Team player that can adapt in a fast pace and changing environment
Commitment to exemplifying the organizational core values and key competencies

Competitive base pay and performance bonuses, dependent on role
Medical, dental, vision, telemedicine, supplemental insurance benefits, long-term and short-term disability
401K with employer match and 100% immediate vesting
Paid Time Off (PTO) and paid company holidays to help you balance work and personal life
Paid Volunteer Time Off (VTO) Annually
Tuition Reimbursement
Parental Leave
Business casual work environment

Data Developer

Key skills