Job Description
Job Specifications
Close Date: This position will close at midnight (CST) on July 11, 2024.
Our company is looking for an experienced technologist who loves solving complex software and data problems. In this role, - You will interact with our internal clients and other team members to gather requirements - You will be working very closely with the business analysts to build the required models and provide solutions to data problems with creativity & innovation. - You will develop specifications, construct, enhance, and maintain processes - You will be supporting Enterprise Data & Analytics environments and perform on-call support on a rolling calendar basis.
Pay Range: $92,500 - $152,450
(This posting includes the full pay range for this position. Pay is based on a number of factors and may vary depending on job-related knowledge, skills, experience, and internal equity.)
Reporting Relationship: Data Solutions Manager
Location: This position may be located in Fayetteville, Arkansas; Council Bluffs, Iowa; or Rapid City, South Dakota.
Relocation Assistance: Relocation assistance is available based on individual circumstances! Details to be shared during the offer process.
Essential Functions:
Collaborate with cross-functional teams in different data domains to understand business requirements and provide data-driven recommendations and solutions.
Design, develop, and maintain data models, data dictionaries, and future ready data solutions. Follow industry best practices and ensure solutions are scalable, reliable, and secure in the data space.
Ensure that all solution artifacts & documentation are completed in regard to the requirements, with the need to seek approval before commencing any work.
Manage data quality & integrity, including identifying and resolving data anomalies and inconsistencies in a timely manner.
Perform project management tasks on varied sized projects as necessary.
Provide mentoring & guidance to junior IT colleagues in the ongoing development of enterprise data cloud.
Design, develop and implement Power BI semantic models as needed.
Provide on-call support for enterprise data cloud applications on a rolling calendar basis.
Strive to continuously improve solution delivery processes and practices.
Apply several data profiling techniques to document and validate the structure, quality, and compliance of source data.
Additional Responsibilities:
Maintain IT and SOX compliant status and work with appropriate teams to document and review on a timely basis.
What You'll Need:
Bachelor's Degree Information technology or related specialty, or equivalent combination of education and experience
5 or more years Hands on experience working & developing solutions for data engineering and analytic use cases.
Advanced knowledge of SQL languages, predominately TSQL and PL/SQL.
Extensive understanding of relational databases, data warehouse architecture & principles and dimensional database models (star schema).
Advanced knowledge of information engineering concepts, including business area analysis, business system design, data modeling, data security and application construction.
Customer service mindset, ability to work effectively in a professional manner with technology staff, business stakeholders, end users. management and others outside the organization.
Ability to lead meetings with technical peers and upper management regarding data and analytics solutions.
Ability to set priorities, handle multiple projects and meet deadlines with no oversight in an agile work environment.
Strong analytical, communication, and collaboration skills.
What Is Desired Or Can Be Taught:
Any cloud certifications related to data. Upon Hire
Solid understanding of cloud data infrastructure including but not limited to Azure Data factory, Azure Synapse, Microsoft Fabric, Power BI
Solid understanding of big data technologies such as Apache Spark to process & handle large datasets.
Excellent understanding of Data Lake, Serverless Architecture & Delta Lake to implement Lakehouse Architecture.
Good understanding of extracting data through REST; Working knowledge of processing and storing complex data structures ingested through REST.
Working knowledge on Azure DevOps including but not limited to creating build & release pipelines, DACPAC deployment, YAML, familiarity with pull request and branch merging strategies.
Overall understanding of Power BI & Semantic Models.
Good understanding of Azure Event Grid based data movement framework
Black Hills Corporation
625 Ninth St
Rapid City
South Dakota United States
ir.blackhillscorp.com/
