BI Developer

TTI, Inc.•Fort Worth, TX

11h•Onsite

About The Position

TTI, Inc. is seeking a BI Developer in Fort Worth, TX to develop and implement efficient data ETL processes, design Business Insight solutions using Microsoft BI tools, and serve as a design lead for BI development projects. This role involves interacting with management, coordinating with senior management for approvals, and verifying BI views with business stakeholders and data scientists to ensure they meet business needs. The developer will provide technical support, troubleshoot issues with urgency, write ad-hoc queries, and analyze reporting simplification. The position also involves assisting in the expansion of big-data NoSQL databases to complement the Enterprise Data Warehouse and working with team members and citizen data scientists to proliferate NoSQL database querying. Continuous learning and staying updated on BI technology trends, such as data lakes and NoSQL, are essential. The role requires understanding and communicating business data use to DBAs and assisting in the design of data in dimensional models for data marts/data warehouses.

Requirements

Bachelor’s degree in Business Analytics, IT, or related (or its equivalent) and 2 years of experience in related occupations.
2 years of experience in working with relational databases, schemas, dimensional modeling, and data analysis techniques
1 year of experience in report writing tools such as SSRS or Power BI Paginated Reports
1 year of experience in MS SQL querying, specifically SELECT queries and stored procedures
1 year of experience in dimensional modeling concepts
1 year of experience in NoSQL querying and development
Master’s degree in Business Analytics, IT, or related (or its equivalent) is an alternative.
Working with relational databases, schemas, dimensional modeling, and data analysis techniques
Report writing tools such as SSRS or Power BI Paginated Reports
MS SQL querying, specifically SELECT queries and stored procedures
Dimensional modeling concepts
NoSQL querying and development

Responsibilities

Develop and implement efficient and accurate data ETL processes.
Design static and dynamic Business Insight solutions using Microsoft BI tools.
Serve as the design lead for BI development projects by interacting with management, while coordinating and obtaining the approval from senior management.
Interfaces and verifies with various business stakeholders and data scientists that the static and dynamic BI views meet and support the business needs that these were created to fulfill.
Provides technical support for all BI views by troubleshooting and resolving any issues with a sense of urgency.
Write ad-hoc queries and reports to provide business insights into the questions posed by senior leadership within and across business units.
Analyze and support the simplification of the current corporate and departmental reporting.
Assist in expansion and implementation of big-data NoSQL database to serve as a data lake to complement the existing Enterprise Data Warehouse. Work with members of the BI team and identified citizen data scientists to proliferate the querying of NoSQL database.
Continually increases technical knowledge and proactively applies knowledge by keeping abreast of changes in technology (e.g. staying up-to-date on BI technology trends such as data lakes & NoSQL, taking technology related classes, etc.) and by recommending technical solution changes if appropriate.
Understand and communicate business use of data to DBAs. Assist in layout and design of data in dimensional models to be used in data marts/data warehouse.