Job Details

Data Developer II

The Data Developer II is responsible for building fast, reliable, transparent, and scalable business-focused information systems. This position designs and builds standardized ETL processes used to populate the data warehouse and feed data to external partners. The position also leverages data query tools to help present data in various data visualization tools. The position consults architects, analysts, and stakeholders toward the efficient and effective use of SQL to perform their analytic and Business Intelligence functions.

How Will You Drive Value Within The Organization As A Data Developer II?

1. 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
2. Design and build data warehouses/data lakes/data marts to provide easy access to structured and semi-structured data for analysts/data scientists
3. Design, build, enhance, and maintain reliable and performant batch and real-time interactive PowerBI dashboards and SSRS reports working from specification documents and/or direct interaction with business users
4. Automate and optimize ad-hoc reports, manual data processes, and user queries, through data research and understanding
5. Set-up internal and external secure data exchanges using industry standard encryption techniques
6. Implement data security measures to protect PII and other sensitive information
7. Integrate processes and tools to monitor and improve data quality and system stability as prescribed by the data governance team
8. Review and provide feedback to other developers with an emphasis on efficiency, quality, and maintainability
9. Foster a collaborative culture that facilitates the achievement of business plan objectives by working closely with other associates and members of management
10. Perform additional assignments and special projects as required by the needs of the company or as directed by management

What Should You Already Know To Be Successful As A Data Developer II?

• Minimum of bachelor's degree required
• Minimum of two (2) years' experience in either ETL, BI (building charts and graphs), or Statistical Analytics fields required
• Must be proficient in SQL including joins, inserts, updates, deletes, conditional logic, subqueries, temp tables, and complex data transformation functions
• Knowledge of relational database management systems and data warehouse system required
• Experience reviewing datasets for data quality required
• Experience with programming languages like Python required
• Experience with unstructured or semi-structured data (ex. XML, JSON) preferred
• Experience with data integration tools like Airflow or Prefect preferred
• Experience with different data security algorithm 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

Employment Requirements:

• Must be able to work at a desk/in a seated position up to 100% of the workday
• Must be able to constantly operate a computer and other standard office equipment
• Must be able to talk and hear to exchange accurate information
• Must have close visual acuity to perform activities such as: preparing and analyzing data and figures; viewing a computer terminal; extensive reading
• This position is full-time
• This position does not require travel