BI Reporting and Information Architect

Posted:
4/16/2024, 5:00:00 PM

Location(s):
George Town, Penang, Malaysia ⋅ Penang, Malaysia

Experience Level(s):
Mid Level ⋅ Senior

Field(s):
Data & Analytics

Our vision is to transform how the world uses information to enrich life for all.

Micron Technology is a world leader in innovating memory and storage solutions that accelerate the transformation of information into intelligence, inspiring the world to learn, communicate and advance faster than ever.

JR52723 BI Reporting and Information Architect

The Business Intelligence (BI) Developer supports and expands the Business Management team's business intelligence solution(s), primarily a custom data warehouse built in SQL Server, and reports developed in Microsoft's SQL Server Reporting Services (SSRS), Excel, Tableau and/or Power BI. They will play a critical role in all phases of the solution's life cycle. This includes participating in or leading requirements definition, data analysis, data modeling, data warehouse development, modeling and piloting emerging technologies and toolsets, ETL design and development, data integration from disparate data sources, reports creation and deployment, and database cleansing efforts. The BI Developer will focus on building reports that enable support and creation of the Business Management team’s process. This position interviews key partners on report requirements and builds tools that enable the team to work efficiently and accurately. Ultimately, it is the goal of the BI Developer to help ensure the reporting and analysis align with the Business Management team’s charter.

Responsibilities include, but not limited to:

  • SQL development in a production environment: develop, test and document stored procedures, views, tables, indexes, constraints, functions and/or SQL scripts. Prepare detailed and comprehensive documentation for al programs.
  • Interview key partners about reporting needs: work regularly with the Business Management team members to identify new reports and changes to existing reports; communicate with team members about report requirements; design, test and vet the final report results with relevant team members
  • Develop and maintain standardized reports using the most appropriate tool which could include (Power BI/Tableau/Excel/SSRS): build/support a suite of reports that are scheduled and delivered electronically or are available on-demand in a self-service environment for Business Management team members
  • Using Microsoft's Integration Services (SSIS), expand and support the SQL Server-based data warehouse and associated ETL processes for reporting and analysis for the Business Management Team. Provide ample documentation on the data warehouse and associated reports. Use Microsoft's SQL Server Management Studio (SSMS) throughout all phases.
  • Develop methods to identify data anomalies and broken business rules within operational and transactional data systems. Assist in developing data integrity solutions and data cleanup processes.
  • Other duties as requested or required

Minimum Qualifications:

  • Bachelors in Computer Science and/or Information Technology with 10 years of experience or Masters in Computer Science or MCA with 5 years of experience
  • Proficient in:
    • Microsoft Office/VBA expertise
    • Microsoft SQL (SSMS) – database design
    • SSIS – SQL Server Integration Services
    • SAP
    • Business Objects (BOBJ)/SAP Crystal Reports
    • Knowledgeable in Git/Subversion
    • POWER BI
    • Tableau
    • ActiveBatch
    • Microsoft Visual Studio/Visual C# to support GUIs

Preferred Skills:

  • Experienced in Microsoft Office VBA to support existing reports
  • Knowledge of SAP (transactions, underlying table structure and fields available for reporting)

About Micron Technology, Inc.

We are an industry leader in innovative memory and storage solutions transforming how the world uses information to enrich life for all. With a relentless focus on our customers, technology leadership, and manufacturing and operational excellence, Micron delivers a rich portfolio of high-performance DRAM, NAND, and NOR memory and storage products through our Micron® and Crucial® brands. Every day, the innovations that our people create fuel the data economy, enabling advances in artificial intelligence and 5G applications that unleash opportunities — from the data center to the intelligent edge and across the client and mobile user experience.


To learn more, please visit micron.com/careers

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

To request assistance with the application process and/or for reasonable accommodations, please contact [email protected]

Micron Prohibits the use of child labor and complies with all applicable laws, rules, regulations, and other international and industry labor standards.

Micron does not charge candidates any recruitment fees or unlawfully collect any other payment from candidates as consideration for their employment with Micron.

Micron Technology

Website: https://micron.com/

Headquarter Location: Boise, Idaho, United States

Employee Count: 10001+

Year Founded: 1978

IPO Status: Public

Last Funding Type: Post-IPO Equity

Industries: Computer ⋅ Hardware ⋅ Manufacturing ⋅ Semiconductor