The Dolese Promise is built on a foundation of integrity driven by our passion for quality, safety, and reliability. We are one of Oklahoma's most respected employee-owned companies because of our people and our values. We strongly believe in positively impacting our communities through our products, our actions, and our financial support.
Being a part of the Dolese team affords a unique opportunity to join an organization that rewards its owners through profit sharing. Our employees are one of our most important resources, which is why we promise to deliver.
Treat with Respect
JOB SUMMARY :
As a Business Intelligence Developer for Dolese, the successful candidate will primarily create/manage enterprise-class, scalable and supportable analytics solutions that will be leveraged to help drive measurable, data driven business decisions. The candidate will play an active role within all aspects of the data lifecycle (ingestion, cleansing, modeling, and visualizing). Working alongside the Senior Data Architect, the candidate will have a background in data and business analysis as well as a problem-solving aptitude. The candidate must also demonstrate the ability to collaborate and effectively work with other IT and business units throughout the planning, designing, testing, and implementation phases. Strong communication skills are also required when dealing with internal and external parties, including vendors and business partners.
KEY RESPONSIBILITIES/ESSENTIAL FUNCTIONS :
Design, implement, and maintain complex ETL/ELT processes
Develop and execute database queries and conduct analysis
Effectively land and model data within the enterprise data warehouse
Design, build and deploy visualizations and reports for requested projects
Translate business needs to technical specifications
Develop and update technical documentation
Work with business units to refine requirements to enhancements and new report requests
Work effectively within a team-oriented environment
Maintain a customer-focused attitude
Ensure design and development standards are current and being followed
Ability to effectively manage multiple initiatives concurrently
Develop scalable solutions to meet business needs
Other duties assigned as needed
BSc/BA in Computer Science, Management Information Systems or relevant field, or comparable experience
3-5 years of SQL experience, specifically reading and writing T-SQL objects (tables, views, procs, functions)
3-5 years of MS-SQL experience
1-3 years of ELT or ETL experience
Experience creating data visualizations in a BI tool would be highly preferred
SSRS or SSIS experience is highly desired
Familiarity with DAX is highly desired
Familiarity with Azure is highly desired
Toolsets: Familiarity with any of these are highly desired.
PowerBI Attunity Matillion Azure Data Factory
DBT Snowflake SSIS/SSRS Azure DevOps
Lift, push or pull objects of various dimensions up to 30 lbs. of weight frequently
Ability to perform 80% sedentary work and tolerate prolonged standing / sitting / walking
Ability to repeatedly balance, bend from the trunk, crawl, kneel, push and pull objects
Ability to use hands and fingers to handle or feel
Ability to verbally communicate, hear, and specific vision abilities including close vison, distant vision, color vision, depth perception and the ability to adjust focus.
We consider applicants for all positions without regard to race, color, religion, sex, national origin, age, genetics, marital or protected veteran status. Dolese provides 'reasonable accommodations' to qualified individuals with disabilities in accordance with the American with Disabilities Act and applicable state and local laws. If you need a reasonable accommodation in order to complete the application process please contact the Human Resources Director.