Senior BI Developer

Nitel Chicago , IL 60602

Posted 2 months ago

the challenge

You are a data nerd and have both the passion and the ability to turn complex data sets into practical insights. As part of the Business Architecture team, you will play a critical role in partnering with business folks across Nitel to drive the adoption of data-driven decision making by developing insightful and actionable reports. You will primarily be responsible for requirements gathering, design, development, testing, deployment, and support of complex reporting solutions that enable Nitel to make accurate business decisions, ensuring data security and accuracy.

what youll do

  • Create and modify reports in Salesforce and SQL Server Reporting which support the business decision-making process at various levels of the organization

  • Migrate data from Microsoft SQL Server (and other sources) to Salesforce

  • Maintain the structure of relational databases and Nitels data warehouse

  • Resolve and explain data discrepancies and issues; maintain the integrity of existing data

  • Document work, including updating and maintaining the Nitel knowledgebase (Confluence, Intranet, etc.)

  • Meet quality, productivity, turnaround time and other expectations

  • Help ensure continuous improvement of Nitel processes and procedures

what youll bring to succeed

  • Bachelors Degree in Computer Science or related field; Masters Degree a plus

  • 5+ years experience in BI/relational databases and 1+ years in Salesforce reporting

  • Knowledge of relational databases, transaction processing, data warehouse designs, and data modeling

  • Experience implementing Salesforce reports

  • Strong background in SQL programming

  • Experience with Microsoft SQL Server/SSIS/SSRS/SSAS

  • Experience designing and implementing ETL processes

  • Experience building data warehouses and data cubes

  • Ability to present information in a clear, logical and effective manner

  • Effective communication and reporting skills

  • Strong project management skills and the ability to meet deadlines

  • Good judgment, problem-solving and decision-making skills

  • Ability to collaborate and partner cross-functionally

  • Salesforce certification (Dev 401, 501) would be amazing

  • Familiarity with the telecommunications industry [is a huge plus!]

  • Honesty and integrity

what success looks like

  • Quick request turnaround

  • Internal customer satisfaction

  • Reported number accuracy

what we believe

At Nitel, we believe in creating leaders at all levels within the company; our leadership competencies include:

  • Love the Customer

  • Challenge the Status Quo

  • Dream Big

  • Lead, Learn & Develop

  • Think Like an Owner

  • Get It Done

upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior BI Developer

Stryker Corporation

Posted 4 months ago

VIEW JOBS 10/12/2018 12:00:00 AM 2019-01-10T00:00 Job Description The Sr. BI Developer is responsible for delivering full stack self-service BI (Business Intelligence) solutions for various end user groups. The scope of work covers requirements gathering / business case evaluation, solution architecture and design, development, testing, service/software provisioning and configuration, and releases/deployments. These responsibilities will be distributed across Projects, Change Requests, and Operations / Support. The full stack of BI work includes data integration (ETL/ELT), data modeling and data store ingestion (data marts / star schemas), semantic modeling and user access layer development, and visualization / dashboarding. The candidate will be responsible for the technical delivery of approved projects, changes to be delivered within a release cycle, and for providing technical support to new projects through the project management (Agile/SCRUM) framework. For support, the candidate is responsible for providing technical expertise in maintenance, troubleshooting and issue resolution for all BI systems. The candidate needs to able to produce detailed business case, use case, requirements, and technical documents. The candidate will be required to build solutions within assigned application tooling and understand the overall design / architecture of the BI platform. Communication with core team and other teams is critical for both day-to-day events and building out new solutions. This candidate will play a key role supporting both business and technical aspects of the program. Responsibilities: * Identifying and supporting business needs and recommending / providing holistic solutions that integrate with existing data and technical solutions * Identifying and recommending new data analysis / BI needs, new datasets, and new solutions to help business units meet their goals * Working with Business Analysts in understanding system requirements, producing both business process and technical documentation, and translating into BI solutions * Technical Design, Development, Testing and Delivery of self-service BI solutions within a Shared Service Platform / application stack for full stack BI development in the areas of data integration (ETL/ELT), data modeling and data store ingestion (data marts/star schemas), semantic modeling and user access layer development, and visualization / dashboarding * Designing and implementing End User Data Access Layer solutions (semantic layers / models) which allow non-technical end users to create reports and dashboards * Designing and building reports and dashboards for PoCs (Proof of Concepts), production use, and end user training / examples * Managing and supporting all BI solutions * Identifying and acting upon opportunities to improve the system process flow, performance and technical efficiencies Qualifications/Work Experience Preferred: * Minimum of 5 years of relevant experience required in full stack BI development building self-service BI solutions for end user data analysis, data mining, reporting, and dashboarding * Minimum of 2 years of experience working with cloud based solutions in Azure / Power BI, or AWS, or similar * Ability to analyze business situations and apply excellent organizational/communication skills and attention to detail in business case evaluation and requirements analysis * Strong data analysis and problem solving skills, including Excellent SQL (T-SQL, PL/SQL) skills * Experience with Semantic Modeling and tools such as Power BI, Tableau, Business Objects Universe development, or Cognos Framework development * Experience with report development in SQL Server Reporting Services (SSRS) including report models and the Semantic Modeling Language (SMDL), and experience with other tools such as Power BI, Cognos, Business Objects, Crystal Reports, Tableau * SQL Server Analysis Services (SSAS) * Understanding of ELT/ELT concepts * Understanding of OLTP vs. OLAP systems, storage, and reporting techniques (relational vs. multidimensional) * Cube development; understanding of differences between MOLAP, ROLAP, OLAP, Tabular Cubes * Experience with Data Analysis Expressions (DAX) and Multidimensional Expressions (MDX) * Understanding of Kimball vs. Inmon data architecture * Understanding of Star and Snowflake schemas, Facts, Dimensions, and Slowly Changing Dimensions * Familiarity with dimensional data modeling, Multidimensional analysis and report writing * Experience converting user requirements into deliverable reports and analytical data sets * Experience with designing and creating dashboards including best practices and how they contrast to reporting Education/Special Training Required: Bachelor's Degree in Computer Science, Computer Engineering, Computer Information Systems, or equivalent. Work From Home: No Travel Percentage: Up to 25% Stryker Corporation is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex, gender identity, sexual orientation, national origin, disability, or protected veteran status. Stryker is an EO employer – M/F/Veteran/Disability. Stryker Corporation will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. Stryker Corporation Chicago IL

Senior BI Developer

Nitel