IT Business Intelligence Developer
Tempur Sealy International
- Trinity, NC
- $76,000-109,000 per year
- Permanent
- Full-time
- Generous Paid Time Off
- Competitive Medical, Dental & other wellness programs
- Disability and Life Company Paid
- Retirement Plan Options
- Generous Employee Purchase Discounts
- Learn and understand the "as is" environment to be able to provide functional Expertise and knowledge of the existing business practices.
- Ability to reconcile user requirements to technical specifications and new system capabilities
- Design, build, optimize end-to-end BI solutions that integrate numerous data sources, data warehouses, and data marts.
- Participates in the design, development, and analysis of data architecture and warehousing approaches.
- Creates and deploy transactional reports, analytical reports, pivot tables, visualizations and dashboards using various tools
- Participates in peer reviews (including architectural reviews, project reviews, requirement reviews, and logical model reviews);
- Tunes warehouse builds, reports and SQL statements driving both.
- Understands how the application interacts in a technical environment (e.g., network, infrastructure, database, etc.).
- Support, maintain, and modify existing systems and integrations.
- Contributes to overall project status reporting
- Improve processes to accelerate delivery timelines
- Unit test new programs to ensure that logic and syntax are correct and program results are accurate
- Assist with user training as needed, providing guidance with approach, documentation, and presentation
- Coordinate with business users for UAT Testing and signoff
- Troubleshoot questions/problems from the user community
- Coordinate with appropriate persons to ensure that compliance with all policies for system changes
- Awareness and working knowledge of IT infrastructure
- Proficiency in reading and interpreting technical documentation.
- Ability to identify and troubleshoot issues.
- Attention to detail, deadlines and reporting
- Microsoft's BI Stack and Power Platform, e.g. Power Query
- Expertise with Atlas
- Expertise using Excel
- Expertise with Fastpath Autiting Tool
- Expertise with Visualization Tools (i.e. Power BI, SSRS)
- Strong knowledge of Dynamics AX 2012/D365 (especially in the areas listed below)
- Data and data relationships
- Finance and Accounting Processing (including, but not limited to Management Reporter)
- Sales and Invoicing
- Manufacturing
- Inventory
- SQL Server
- Database design and Normalization methodologies
- SQL Server database SQL coding for stored procedures, functions, views etc.(Master Level)
- Ability to build, execute and Tune SQL queries for data requests from AX Data (Master level)
- SSRS (Reporting Services)
- SSIS (ETL)
- SSAS (Analytical Services - multi-dimensional and tabular data models)
- Familiar with SharePoint
- Familiar with data modeling tools, (e.g. Snowflake) a plus
- Familiar with data modeling methodologies
- Expertise in MS Word, Visio, Excel
- Visual Studio and Team Foundation Server
- Up-to-date with current technology trends
- Proficiency in business applications strategy and implementation
- Excellent analytical skills
- Detail oriented
- Deep understanding of IT Policies and Procedures
- Strong verbal and written communication skills
- Effective diagramming skills
- Contributes to a cooperative environment that fosters knowledge sharing.
- Provide technical guidance and mentoring to others in areas of Expertise
- Works effectively in a dynamic, collaborative environment.
- Works well with people that have different views
- Displays a sense of urgency and shows a strong sense of purpose.
- Sets standards of excellence
- Ability to take initiative and be innovative
- Looks toward the broadest possible view of an issue/challenge
- Ability to identify system impact for small- and large-scale initiatives
- Ability to effectively manage multiple, competing, high-priority projects with varying deadlines
- BSc/BA in Computer Science, Engineering or relevant field with a minimum 5 Years of experience in a similar technical role