Job description

This is a hybrid position, both in-office and remote.

Delta Dental of Michigan may be required to comply with applicable federal, state, and local COVID-19 workplace safety laws, regulations, and/or orders. Delta Dental of Michigan reserves the right to require all employees, as a term and condition of employment, to comply with such requirements or obtain an approved medical or religious accommodation in accordance with applicable law.

Delta Dental of Michigan, Ohio, and Indiana is a leader in dental benefits, plus so much more.

We improve oral health through benefit plans, advocacy and community support, and our corporate giving builds healthy, smart, vibrant communities for all. We devote our time, talents and financial resources to improve oral and overall health, and we invest in initiatives that support youth, education, workforce and economic development.

We are a force for good--part of the reason why employees find working at Delta Dental fulfilling.

Delta Dental companies nationwide comprise the Delta Dental Plans Association, which provides coverage to more than 83 million Americans and operates two of the nation's largest networks of participating dentists.

For more, visit www.deltadentalmi.com and www.vibrantcommunities.com, and apply online at www.deltadentalmi.com/careers.

Job Summary:

Perform data model design, leveraging ETL to move data from existing systems to Salesforce, and map and transform data sets for migration into or out of Salesforce.

Primary Job Responsibilities:

Creates and maintains data integrations with the Salesforce application to ensure seamless and efficient flow of data.

Analyzes the data quality, aligns technical design to data governance, and addresses all the required non-business but operational requirements during the design and build of data pipelines.

Partners with Salesforce Administrators, Developers and other technical teams/data engineers to understand and aid in the implementation of new data functional solutions, analyze performance of new data integrations, and troubleshoot issues.

Collaborates with technical teams to develop test data for specific use cases required by operations team and project teams.

Creates and manages queries to analyze large and complex data sets for project or operational requests.

Develops and optimizes SQL statements using SQL Developer and Informatica, and creates tasks, task flows, queries and task/job schedules using Informatica Cloud ETL.

Assists with the evaluation and integration of third-party software and the preparation/delivery of data to and from approved external sources.

Troubleshoots issues with complex data mapping, and collaborates with team members, technical teams, customers or other departments to resolve.

Creates documentation which includes database objects affected, specifications, and flows/diagrams to detail the proposed data migration process for future data migrations into Salesforce.

Assists in the creation of test automation strategies as it pertains to how existing data can be leveraged.

Performs system management functions such as monitoring, disaster recovery, and backup.

Perform other related assigned duties as necessary to complete the Primary Job Responsibilities as described above.

Requirements:

Position requires a bachelor’s degree in computer science, information technology, or related field, and three years database management design and maintenance. Salesforce Administration or Salesforce Developer experience preferred. Will accept any suitable combination of education, training, or experience.

Position requires experience in data integration, ETL (Extract, Transform, Load) development/management, and database design or data warehouse design; experience working with Salesforce APIs or migration tools preferred; experience working with SQL scripting, data orchestration/ETL tools, like Mulesoft or Informatica IICS, ingesting and outputting different file formats (i.e., .CSV files) and familiarity with data management: Data governance, data dictionary, data quality, HIPAA compliance, etc. preferred; knowledge of version control and configuration management processes and best practices is preferred; strong communication and organizational skills; willingness to learn new technologies and tools; and knowledge of data de-identification tools and processes preferred.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday

Work Location: Hybrid remote in Okemos, MI 48864

seankuhnke.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, seankuhnke.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, seankuhnke.com is the ideal place to find your next job.