Programmer II

Programmer II

Requirements

• Advanced knowledge of SQL and in-depth experience using Microsoft SSIS & SSRS, and Python.
• Extensive knowledge in Microsoft Power BI, Power BI Desktop, Service, Gateways, Incremental data refresh, and Row level security.
• Proven experience using programming languages such as R, Python, and Powershell.
• ETL experience in a data warehouse environment using slowly changing dimensions.
• Proven ability to ingest and manipulate data in Power BI from multiple source systems using complex SQL queries and DAX to create production ready data models.
• Experience using version control tools such as Git, Bitbucket or similar central repository tools.
• Familiarity with NoSQL Databases.
• Current knowledge of laws, rules, and regulations pertaining to information technology relating to financial institutions.
• Ability to work independently with limited supervision.
• Ability to develop and implement technology projects.

Responsibilities

• Design and develop ETL processes to transform a variety of raw data, flat files and excel spreadsheets into SQL databases.
• Develop and optimize queries, stored procedure, functions, views, and automation scripts using SQL, TSQL, Python, C#, and / or Powershell.
• Utilize data management best practices and in-depth usage of Microsoft SSIS & SSRS to accomplish business initiatives.
• Create and maintain a complex reporting structure including data storage systems, data sets, reports and dashboards using SQL queries, stored procedures, and programming languages such as R and Python.
• Evaluate business requests for data and reports to determine feasibility, cost and time required, compatibility with current systems, and effectiveness.
• Develop business requirements and technical requirements for reporting/visualizations, data models, and databases. Create technical specifications derived from technical requirements.
• Design and develop enterprise, departmental business intelligence and data warehousing solutions.
• Create and improve existing data warehouse processes, optimize reporting, and improve data integrity throughout organization.
• Responsible for daily support of ARCU/Post ARCU ETL jobs completion and remediate issues.
• Create and modify programs to run on the core processing system.
• Manage assigned work queue on a constant daily basis, updating requests with comments as necessary.
• Prioritize daily schedule as work dictates.
• Provide on-call support for critical production systems.
• Complete assigned programming tasks and projects as required.
• Document created code in accordance with direction and company standards.
• Program, test, debug and administer computer software and processes.
• Employ project management tools and methodologies in completion of programming projects and initiatives.
• Develop and maintain user guides, diagrams, procedures, and business continuity information.

Preferred Qualifications

• Familiarity with JIRA preferred.
• Preferred experience with Azure: Data Factory, Databricks, Data Lake Storage, Analysis Services, and API – PySpark.