Data Solutions Engineer Senior Location: Fayetteville, AR, United States Job ID: 35627 Date Posted: Feb 13, 2025 Position will close at 12:00am CT on Feb 17, 2025 Salary: $ 94800 to $ 156250 Annually Share: share to e-mail Apply Now > Job Description Job Specifications Black Hills Energy is people powered and purpose driven. Our team uses the power of energy to improve life for over one million customers in 800+ communities across the West and Midwest. We seek talented, caring people who embody our core values and contribute to a culture of inclusion and growth. As an organization, we believe the best part of working on our team is our commitment to making tomorrow better than today—for our customers, communities and each other. Position summary: 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 and Analytics environments and perform on-call support on a rolling calendar basis. Pay Range:$94,800 - $156,250 (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: Rapid City, South Dakota; Fayetteville, Arkansas; Denver, Colorado; or Council Bluffs, Iowa 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. • 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. • Design, develop and implement Power BI semantic models as needed. What Is Required: • Bachelor’s degree in Information Technology or related specialty; or equivalent combination of education and experience is required. • Minimum of five years of hands-on experience working and developing solutions for data engineering and analytic use cases is required. • 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: • Any cloud certifications related to data. • 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. This description is not intended to be an all-inclusive list of responsibilities, duties, and requirements for employees in this position. Job descriptions may and do change periodically. Where positions are covered by a collective bargaining unit agreement, the terms and conditions of the agreement will apply. About our Company:We are a customer, growth and safety focused utility company that is dedicated to our communities. We improve life with energy as an energy partner of choice. Our diverse culture fuels unique perspectives, opening doors to new insights and possibilities. Based in Rapid City, South Dakota, we have over 3000 employees and serve 1.3 million natural gas and electric utility customers across eight states (South Dakota, Montana, Wyoming, Colorado, Nebraska, Iowa, Kansas, and Arkansas). Enjoy our Comprehensive Benefits Package! Annual discretionary bonuses, 401(k) (6% company match and up to 9% company retirement contribution), tuition reimbursement, generous paid time off benefits, including paid holidays and parental leave, company paid life insurance and disability benefits (short and long term), an employee assistance program and well-being benefits, and competitive medical, dental and vision insurance. Candidates must successfully pass a pre-employment drug screen and background check. Black Hills Energy does not sponsor applicants for work visas. All applicants must be legally authorized to work in the US. We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or status as a protected veteran. If you require reasonable accommodation, please visit careers.blackhillsenergy.com for more information. Wage: 94800 to 156250 Share: mail Apply Now >