16 Etl Developer jobs in Columbus

JOB DESCRIPTION

Job Summary

The Azure ETL Developer is tasked with designing and developing Azure Data Factory solutions, covering projects of moderate to high complexity. This position also necessitates proficiency in Microsoft SSIS ETL solutions to support the architecture, development, and migration of legacy solutions to Azure Data Factory. Candidates should possess three to five years of experience with the Microsoft ETL stack, including experience in SSIS, SSRS, T-SQL, and Azure Data Factory. Furthermore, the role requires a comprehensive understanding of emerging technologies and the capability to design, research, and implement innovative solutions.

Knowledge/Skills/Abilities

• Proven ability to architect and develop solutions which perform data transformations using Azure Data Factory

• Strong knowledge of SQL Server, SSIS and t-SQL, preferably on Azure and/or SQL 2016+ Design and develop SQL Server stored procedures, functions, views and triggers

• Design, implement and maintain SQL database objects (tables, views, indexes) and database security

• Debug and tune existing SSIS/ETL processes to ensure accurate and efficient movement of processed data

• Collaborate with Product Owners to elicit and document business requirements for ETL and report design.

• Ability to translate business requirements into sound technical specifications

• Research issues and sets up proof of concept tests

• Support quality acceptance testing which includes the development and/or refinement of test plans

• Lead design review session with scrum team to validate requirements

• Troubleshoot data quality issues and defects to determine root cause

• 5+ years ETL development experience with 1-3 years utilizing Azure Data Factory

• Experience working with Azure SQL Database, DevOps, GIT and Continual Integration (CI)

• Knowledge and/or experience of the Agile framework and working in a scrum team

• Familiarity with healthcare data and concepts

• Familiarity with QNXT

• Excellent analytical and problem-solving abilities

• Strong written and oral communication skills

Required Education

Bachelor's Degree or equivalent combination of education and experience

To all current Molina employees: If you are interested in applying for this position, please apply through the intranet job listing.

Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V.

Pay Range: $77,969 - $120,000 / ANNUAL

*Actual compensation may vary from posting based on geographic location, work experience, education and/or skill level.

Summary:

Responsible for developing and maintaining the database structure that supports the bank's operations. Designs and documents database schemas, writes and debugs stored procedures, while optimizing query performance. This position requires the ability to design database systems that store and provide secure access to customer and financial information.

Qualifications:

Education: Bachelor's degree in a computer related discipline.

Experience: Five years of experience in the card payment industry in a database role. Experience with data visualization and big data analytics tools such as Tableau, Hive, and Power BI. Experience with developing complex ETL in Data Processing environments. Knowledge of multiple database technologies such as mySQL, SQL Server, and cloud services like AWS and Snowflake. Experience with relational and non-relational database platforms.

Essential Functions:

• Designs and develops banking solutions for data, and reporting needs.
• Works with the Manager of Data Analytics and Operations (DAO) to ensure that the Sutton Bank database aligns with the overall needs of data stakeholders.
• Collaborates on the design of database architecture and configure databases to meet the institution's functional requirements.
• Assists in test environment data requirements setup and maintenance, testing and validation.
• Assists with designing new data pipelines as part of onboarding additional payment processors, programs, and third-party data sources.
• Works with Manager DAO to investigate and resolve application and data integrity issues.
• Builds high-quality processes that adhere to the software development lifecycle.
• Utilizes source control for migration of code changes through SDLC.
• Thoroughly understands the processes provided on the Sutton Data Lake.
• Creates database tables, views, and stored procedures.
• Performs data modeling to design efficient database systems.
• Updates and creates database objects such as tables, views, stored procedures, and security credentials to store and access business data.
• Establishes backup, recovery and disaster prevention procedures to ensure data continuity.
• Develops, implements, and maintains database security.
• Develops and executes Structured Query Language (SQL) scripts to manage and manipulate data.
• Monitors and optimizes the performance of databases.
• Installs and configures snowflake cloud computing technologies.
• Creates documentation to ensure databases adhere to industry standards.
• Produces monthly and quarterly reports from database query results.
• Updates and maintains the Sutton Bank Data Lineage tool.

Knowledge/Skills/Abilities:

• The ability to communicate effectively and clearly, both in verbal and written communications.
• Strong knowledge of the Payments Industry and/or card processing.
• A demonstrated understanding of the financial services industry.
• Ability to define problems, collect data, establish facts and draw valid conclusions. Ability to solve problems and deal with a variety of concrete variables in situations where only limited standardization exists.
• Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
• Must have ability to analyze and solve complex problems, develop automated systems.
• Self-directed and motivated.
• Proven ability to support multiple projects simultaneously in a deadline-driven environment.
• Excellent problem-solving skills.
• Ability to articulate technical concepts both written and oral.
• Ability to read, analyze and comprehend general business periodicals, professional journals, technical procedures, audit reports, or governmental regulations.
• Ability to respond to common inquiries or complaints from employees, vendors and management staff.
• Ability to effectively present information to individuals one-on-one or a small group setting.
• Ability to learn new languages and technologies.
• Ability to work with SQL to develop IDE's.
• Ability to work with database technologies like mySQL, Oracle, SQL Server.
• Ability to manipulate data for meaningful reporting.
• Must be a self-starter with the ability to work effectively, both independently and in team settings, to include close collaboration with Processors.
• Excellent understanding of database concepts including normalization and relational data models.

Sutton Bank is an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, sexual orientation, pregnancy, gender identity, disability or protected veteran status.

• Create innovative data solutions within a polyglot database environment.
• Develop unique approaches to ETL solutions and API data integrations.
• Design, support, and maintain OLTP environments for all development.
• Champion the use of the right technology for the task, while utilizing a range of different technologies.

• Bachelor's degree in Computer Science (or equivalent experience).
• 4+ years of experience in relational database development or administration, with preference given to experience in MSSQL or Oracle.
• 1+ years of experience in developing or architecting with NoSQL technologies.
• 2+ years of experience in developing with .Net or Python is a plus.
• 1+ year of experience in developing with APIs and/or Microservices is a plus.
• Knowledge of the automotive industry is a bonus.

• Precision Matching: We'll pinpoint the perfect candidates.
• Time Saver: Fill crucial roles faster than ever.
• Showcase Your Brand: Attract top talent aligned with your mission.
• Partnership: We're your allies in successful hiring.
• Network Access: Tap into our extensive candidate pool.
• Confidentiality: Your needs are handled discreetly.

• Collaborate with business units to identify project requirements.
• Analyze technical requirements and feasibility for projects.
• Provide cost/benefit analyses for proposed projects.
• Plan, organize tasks, and coordinate with development teams.
• Identify and implement internal process improvements.

• Perform advanced programming assignments following established standards.
• Design application and database components.
• Analyze business models and customer requirements to build internet solutions.
• Write optimized SQL queries and work with various databases.
• Mitigate risks in technically complex projects.
• Guide full stack developers in creating performant queries.

• Maintain and modify existing applications and documentation.
• Provide support for critical application issues.
• Analyze and improve SQL query performance.
• Act as a Subject Matter Expert for production problems.
• Coordinate efforts of other developers.
• Conduct research on modern technologies and tools.

• Mentor and train development teams.
• Manage projects and report progress.
• Make presentations to management and peer groups.
• Schedule and lead project meetings.
• Provide tier 2 on-call support for critical issues.
• Analyze and correct program performance deficiencies.
• Attend management meetings on behalf of the team.
• Perform application server maintenance tasks.
• Address internal audit concerns for compliance.

• 5+ years of IT experience.
• 5+ years of experience developing OLTP database applications in Oracle and UNIX/Linux/Solaris environments.
• Proficient in PL/SQL Types, Collections, SQL Loader, Functions, Procedures, Packages, Materialized Views, Triggers, Complex SQLs, and SQL Reports.
• Experience with PL/SQL techniques in LOBs, Multilingual character conversion, and Oracle Performance Tuning.
• Experience with relational SQL and NoSQL databases, data transformation, data structures, metadata, and workload management.
• Experience in building and optimizing data pipelines and architectures.

• Strong verbal and written communication skills.
• Responsive to new learning opportunities and professional growth.
• Motivated and committed to contributing appropriate time and effort to tasks.
• Detail-oriented with a focus on accuracy and timely results.
• Organized with effective prioritization skills.
• Team-oriented with strong interpersonal skills.
• Customer-focused with a strong service orientation.
• Advanced analytical and problem-solving abilities.
• Committed to inclusion and diversity.

• The role involves occasional work outside standard office hours and on-call availability.

• Precision Matching: We'll pinpoint the perfect candidates.
• Time Saver: Fill crucial roles faster than ever.
• Showcase Your Brand: Attract top talent aligned with your mission.
• Partnership: We're your allies in successful hiring.
• Network Access: Tap into our extensive candidate pool.
• Confidentiality: Your needs are handled discreetly.

Experienced Medidata RAVE programmer to maintain Rave URL and be the point of contact for other teams using Medidata applications such as CTMS, eCOA, Safety Gateway.

• Subject Matter Expert on Medidata applications who can advise and teach across functional areas

• Maintain Core Configuration, ensuring consistency and efficiency across all studies

• Maintain Cloud Admin EDC roles, ensuring consistency and efficiency across all studies

• Communicate updates/potential impacts on above to teams

• Communicate and assess impact of Medidata release notes, updates to eLearnings, Rave reports to teams

• Act as a liaison between Sponsor and CRO programmers

• Act as a liaison for data collection between Sponsor DM and Statistical Programming

• Work with business owners of other Medidata applications

• At least 12 years progressive Clinical Research Experience

• Medidata Rave Certified Study Builder

• 10 years' experience as a database programmer

• Zelta certified builder a plus, but not a requirement

• Bachelors Degree Required

Cytel Inc. is an Equal Employment / Affirmative Action Employer. Applicants are considered for all positions without regard to race, color, religion, sex, national origin, age, veteran status, disability, sexual orientation, gender identity or expression, or any other characteristics protected by law.