Azure Data Factory (Sr. Data Developer)

ADF, Agile, Best practices, Business intelligence, Business partnership, CIS, Communication skills, Consulting, DBA, Data analysis, Data management, Data modeling, Data retention, Data warehouse, Data-flow diagrams, Database, Database design, Database performance tuning, Documentation, ETL, Finance, IT management, Information security, Infrastructure, Integration, LESS, Leadership, MDM, Mentorship, Microsoft Office, Microsoft SQL Server, Microsoft SSIS, Microsoft Visio, Microsoft Windows Azure, Monitoring, PCI, Promotions, Reporting, SQL, SQL tuning, Scripting, Security, Snow flake schema, Software, Software development, Strategic management, Team leadership, Team management, Training, Transact-SQL
Full Time
$110,000 - $120,000
Work from home available

Job Description

Quest Solutions, Inc is looking for a Sr. Level Data Developer with Azure Data Factory (ADF) experience.

 

Candidates must have:

*Azure Data Factory (ADF) development is required
*Secondary skill is SSIS development
*Should be experienced in coding with ADF and working within an enterprise data environment with a data warehouse structure.

 

Overview:

We are seeking a talented Data Developer IV (Azure Data Factory) to serve as a technology data developer lead and expert in SQL tuning on SQL Server or Azure Synapse and/or Snowflake. The Data Developer IV works independently and plays the role of technical lead on key strategic projects as related to data infrastructure, reporting, data triage, master data management, and other related data initiatives. This role acts as a team lead by mentoring all other levels of data developers. The incumbent(s) serve as an advisor to data team management as well as business partners in matters of data, reporting and business intelligence. This position advises on technology industry standards, tools, and practices as well as design and implement best practices for data development. The Data Developer IV partners closely with ET&S (Enterprise Technology & Services), business and operation teams. This position also participates in determining strategic direction for data initiatives and best practices.

 

Responsibilities:

  • Serves as technical lead to strategic and enterprise level data driven projects, collaborates with other areas of ET&S as well as business units.
  • Follows and advises on industry standards and advances on data driven technologies and tools.
  • Designs, implements, and updates best practices for the data development team.
  • Serves as technical lead and mentor to other less tenured data developers and analysts.
  • Acts as Subject Matter Expert (SME) to architectural review board and technology review committee.
  • Creates enterprise level end-to-end data flow diagrams and logical data models.
  • Develops and reviews complex SQL, T-SQL scripts, and Azure Data Factory pipelines for various reporting and data development projects. 
  • Creates and maintains documentation related to data development best practices, enterprise level data flow diagrams, and project code promotion.
  • Provides recommendations to technology tools, products and services in order to help keep our environment on the cutting edge of technology.
  • Serves as technical advisor to database administrators in areas of database optimization, indexing and data retention.
  • Serves as lead data developer on key strategic projects.
  • Develops and designs solutions with security as a critical design requirement for data, systems and applications.
  • Adheres to development processes and standards including code management.
  • Responsible for reporting risks that are identified to the appropriate team and/or management. Additionally, responsible for managing, monitoring and reporting risks within the scope of your work area, to include, but not limited to Information Security risks.

 

 

Qualifications:

  • College degree in CIS, Data Management, Data Analytics, or similar, or equivalent training and/or experience.
  • 10+ years’ experience working in a data function or equivalent position where primary responsibility is working with data, database design and data development is the primary responsibility.
  • Best practices for data development within a PCI environment.
  • Ability to review SQL database plans and recommend changes to developers
  • Strong experience with database optimization, hints, indexing, and join strategies.
  • Ability to analyze enterprise level data sources and determine relationships between disparate sources.
  • Determine methodologies for integration with 3rd party data sets.
  • Expertise in data warehousing and data modeling methodologies, tools and best practices.
  • Financial industry knowledge.
  • Agile methodologies.
  • Expert knowledge of Microsoft SQL stack and Azure Data Factory
  • Excellent communication skills and ability to translate complex concepts to simple and easier terms for business leaders and users of data.
  • Expert knowledge of MS Office tools including MS Visio.
  • Ability to review existing processes and identify logic problems to address.
  • Ability to formulate a plan that aligns and supports to delivery timelines.
  • Ability to lead large data driven enterprise projects.
  • Ability to coach, mentor and lead others in the ET&S area. 
  • Ability to identify, recommend and set best practices for the data developer role. 
  • Must be detail focused.
  • Must possess strong communication skills.
  • Ability to participate in an on-call rotation 1 week out of the month
Dice Id : questsol
Position Id : 6847332
Originally Posted : 7 months ago
Have a Job? Post it