Analytics Consultant - Power BI Developer

• Consult with business line and enterprise functions on less complex research
• Use functional knowledge to assist in non-model quantitative tools that support strategic decision making
• Perform analysis of findings and trends using statistical analysis and document process
• Present recommendations to increase revenue, reduce expense, maximize operational efficiency, quality, and compliance
• Identify and define business requirements and translate data and business needs into research and recommendations to improve efficiency
• Participate in all group technology efforts including design and implementation of database structures, analytics software, storage, and processing
• Develop customized reports and ad hoc analyses to make recommendations and provide guidance to less experienced staff
• Understand compliance and risk management requirements for supported area
• Ensure adherence to data management or data governance regulations and policies
• Participate in company initiatives or processes to assist in meeting risk and capital objectives and other strategic goals
• Collaborate and consult with more experienced consultants and with partners in technology and other business groups
• Design, develop, and maintain ETL/ETL processes and data pipelines
• Design, implement, and optimize data warehouses and data lakes
• Create and manage data models to support business requirements
• Integrate data from diverse sources including databases, APIs, third-party services, and streaming data
• Cleanse, transform, and enrich raw data
• Implement and enforce data security measures
• Independently build, operate, maintain, enhance, publish and sunset BI Products
• Continuously monitor and optimize data pipelines and databases
• Develop and implement automated testing procedures
• Maintain thorough documentation of data processes, schemas, and data lineage
• Collaborate with wider team such as data scientists, analysts, software engineers
• Utilize version control systems to manage code and configurations
• Diagnose and resolve data-related issues and provide technical support

• 2+ years of Analytics experience, or equivalent demonstrated through work experience, training, military experience, education
• Hands-on Proficiency in Business Intelligence (BI) particularly Microsoft Power BI, MS Fabric, Power Automate and Power Platforms
• Hands-on Proficiency in any or all of the programming languages used for analytics & data science such as SAS, Python, PySpark, Spark SQL or Scala
• Hands-on strong knowledge of SQL and experience with database management systems (e.g., Teradata, PostgreSQL, MySQL, or NoSQL databases)
• Familiarity with data warehousing and big data technologies (e.g., Hadoop, Spark, Snowflake, Redshift)
• Experience with ELT/ETL tools and data integration techniques
• Experience optimizing code for performance and cost
• Comfortable with using code and agile process management tools like GitHub and JIRA
• Exposure towards developing solutions for high volume, low latency applications
• Ability to work in a fast paced, highly collaborative environment
• Provide production support for data assets and products as required
• Knowledge of data modelling and data warehousing best practices
• Understanding of data governance, data quality, and data security principles
• Strong problem-solving and communication skills
• Ability to work in a collaborative team environment

Knowledge of cloud platforms (e.g., Azure and/OR Google Cloud)

• Equal opportunity employment
• Accommodation for applicants with disabilities
• Drug free workplace