Enterprise Data Architect

  • location: Smyrna, GA
  • type: Contract
  • salary: $60 - $95 per hour

job description

Enterprise Data Architect

job summary:
ETL Architect is responsible and accountable for the definition, implementation, and advocacy of our overall data architecture, data management, data quality, and data governance vision and strategy.

The ETL Architect will be responsible for the Enterprise Data Warehouse design, which supports critical business operations between the Data Warehouse assets and its consuming Solutions, in such a way as to meet and exceed the company's objectives.

 
location: SMYRNA, Georgia
job type: Contract
salary: $60 - 95 per hour
work hours: 8am to 4pm
education: Bachelors
 
responsibilities:
  • Works with business partners, product development teams, and senior designers to capture requirements, determine a solution that will integrate with existing BI assets, review prototypes, and develop iterative revisions.
  • Responsible for leading the design of prototypes and determining the final design to ensure client satisfaction with the product.
  • Conduct impact assessment with business in order and determine high-level design and size of effort based on requirements.
  • Lead and guide an Informatica based ETL architecture to handle complex business rules while balancing the fulfillment of stringent performance requirements.
  • Drive design and determine the ETL requirements for BI projects.
  • Perform an active, leading role in shaping and enhancing overall ETL Informatica architecture, including ETL standards, patterns, and best practices.
  • Work with the team to ensure standards and patterns are followed.
  • Determines organizational strategies for data integrity validation processes.
  • Establishes policies and best practices for optimizing ETL data throughput/accessibility
  • Identifies opportunities for new architectural initiatives; makes recommendations on the increased scalability and robustness of ETL platforms and solutions.
  • Partner with the Data architect to drive improvements and enhancements to the current data landscape and future strategy.
  • Partner with the Leadership team to ensure the successful delivery of projects.
  • Remain current on new ETL techniques and methodologies and communicate trends and opportunities to management and other developers as needed.
  • Identify opportunities for uses of those technologies to enhance current or anticipated information systems and business goals needs
  • Support ETL developers by providing technical assistance, troubleshooting, and alternative development solutions.
  • Playing a key role in mentoring other staff members and a proven track record in knowledge transfer to other team members and departments.
  • Evaluates existing applications that could address client requirements and makes recommendations from complex projects.
  • Identifies alternative uses of technologies that will enhance current or anticipated information systems and that support overall corporate and business goals that are appropriately aligned with the enterprise architecture.
  • Identifies necessary changes to the current business process.
  • Identifies opportunities for solution sharing and reuse.
  • Assists in the development of ETL-related Service Level Agreements.
  • Communicates risks and ensures understanding of these risks.
  • The ideal ETL Architect should boast 10+ years of experience.
  • The ideal candidate will be an energetic and accomplished individual for the Business Intelligence (BI) ETL Architect position with a technology and solution delivery acumen.
  • Accountable for the successful design, development, and delivery of business intelligence solutions within the client's BI Team.
  • Responsible for driving the overall design and determining the ETL architecture necessary for the BI team to develop and implement large complex projects.
  • Will consult with development teams and works closely with business, developers, architects, project management, business analysts, and QA areas across all of BI to deliver on client's strategies, capabilities, and processes.
  • Scope of the BI ETL Architect role involves all aspects of the project life cycle from inception to implementation and support.
  • This role takes a lead in the department's vision and implementation of the client's BI program - The ETL Architect will drive the development of best practices for the client and mentor developers, analysts, and other members of the BI team.
Required Skills & Experience:

  • 10 years of experience in modeling and business system designs.
  • 8 years of hands-on experience in Informatica ETL development.
  • 5 years of Oracle (or comparable database) experience with BI/DW deployments.
  • Proven experience with STAR and SNOWFLAKE schema techniques is desired.
  • Proven track record as an ETL Architect, leading development teams to deliver successful business intelligence solutions with complex data sources.
  • Extensive background in designing ETL packages (Informatica)
Top 3-5 Daily Responsibilities:

  • Works with business partners, product development teams, and senior designers to capture requirements, determine a solution that will integrate with existing BI assets, review prototypes, and develop iterative revisions.
  • Responsible for leading the design of prototypes and determining the final design to ensure client satisfaction with the product.
  • Conduct impact assessment with business in order and determine high-level design and size of effort based on requirements.
  • Lead and guide an Informatica based ETL architecture to handle complex business rules while balancing the fulfillment of stringent performance requirements.
  • Drive design and determine the ETL requirements for BI projects.
  • Partners with ETL Lead and supports ETL Lead and ETL developers through the development of complex ETL routines to load a dimensional star schema (and supporting layers) and develop error handling processes.
Top 3-5 Required Skills:

  • 10 years of experience in modeling and business system designs.
  • 8 years of hands-on experience in Informatica ETL development.
  • 5 years of Oracle (or comparable database) experience with BI/DW deployments.
  • Proven track record as an ETL Architect, leading development teams to deliver successful business intelligence solutions with complex data sources.
Desired Skills:

  • Analytical skills and enjoys solving complex technical problems.
  • Master's degree preferred.
  • Healthcare experience.
  • Agile development methodology background.
Soft Skills:

  • Ability to manage and make decisions about competing priorities and resources.
  • Ability to delegate where appropriate.
  • Must be a team player/leader.
  • Interpersonal skills for interacting and throughout all levels of the organization.
  • Ability to clearly communicate complex business problems and technical solutions.
Experience/Education:

  • Minimum of ten (10) years of related experience required.
  • Bachelor's degree; Licenses, Certifications, Registrations.
  • Master's degree (preferred)
  • Agile development methodology background (preferred)
 
qualifications:
  • Experience level: Experienced
  • Minimum 10 years of experience
  • Education: Bachelors
 
skills:
  • ETL
  • ORACLE APPS

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    IAM Engineer

  • location: Atlanta, GA
  • job type: Permanent
  • salary: $110,000 - $135,000 per year
  • date posted: 12/22/2020